SELECT dem.last_name, dem.first_name, d.end_date as "End Date", d.BN, CONCAT( "" , dem.demographic_no, "" ) As "DemLink", CONCAT( "", dem.demographic_no, "" ) As "ChartLink", dem.address, dem.city, dem.province, dem.postal, dem.phone, dem.phone2, dem.email, dem.sex, dem.patient_status FROM demographic dem, drugs d WHERE d.BN like "%{search}%" AND d.end_date > "{finish_date}" AND d.demographic_no = dem.demographic_no ORDER BY dem.last_name, dem.first_name, d.end_date ;